|
|
|
|
Joined: Jan 2001
Posts: 56
Member
|
|
Member
Joined: Jan 2001
Posts: 56 |
I'm having a MySql related problem here.. The hosting company doesn't want cooperate, so I guess I will look up the answer myself  I need to know how to tell MySql to disable "query" logging. Basically, my site gets so much traffic, the query log file grew to 1 gigabyte in less than one month. This is a major dilemma because I am only alloted 800 megs :-\ Any help is appreciated.
|
|
|
|
|
Joined: Oct 2000
Posts: 2,222
Veteran
|
|
Veteran
Joined: Oct 2000
Posts: 2,222 |
Look in your /etc/my.cnf for logging options and see if any are enabled.
Also check the command line that mysql is started with, in case it has something like --log-slow-queries in the commend line. If so you'll probably need ot edit the start script.
Picture perfect penmanship here.
|
|
|
|
|
Joined: Jan 2001
Posts: 56
Member
|
|
Member
Joined: Jan 2001
Posts: 56 |
Thanks Dave, I'll give it a shot and let you know Jason
|
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Also, if you use mysqldump to make backups, it has an option for flushing the logs.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 21,080
Joined: March 2000
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,824
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 346
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 23
|
|
|
|
|
|
